/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package SubFeeHead;

import FeeType.FeeTypeBean;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Shailesh
 */
public class SearchSubFeeHead extends HttpServlet {

   
   
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException, SQLException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            int feetypeid=Integer.parseInt(request.getParameter("feetype"));
            String subfeety=request.getParameter("subfeehead");
            SubFeeHeadBean sfb=SubFeeHead.Query.viewSpecificSearch(feetypeid, subfeety);
           if(sfb.getSubFeeTypeId()!=0)
           {
                  FeeTypeBean ftb=sfb.getFeeTypeBean();
                  out.println("<tr id='"+sfb.getSubFeeTypeId()+"'>");
                  out.println("<td><center>");
                  out.println(ftb.getFeeTypeName());
                  out.println("</center></td>");
                  out.println("<td><center>");
                  out.println(sfb.getSubFeeType());
                  out.println("</center></td>");
                  out.println("<td><center>");
                  int val=sfb.getDuration();
                  if(val==1){
                      out.println("Once in a Session");
                  }
                  else if(val==2){
                      out.println("Annually");
                  }
                  else if(val==3){
                      out.println("Half Yearly");
                  }
                  else if(val==4){
                      out.println("Quarterly");
                  }
                  else if(val==5){
                      out.println("Monthly");
                  }
                  out.println("</center></td>");
                  out.println("<td><center>");
                  out.println("<a href='EditSubFeeHead.jsp?sfhid="+sfb.getSubFeeTypeId()+"&ftid="+sfb.getFeeTypeId()+"&ftname="+ftb.getFeeTypeName()+"&sfhname="+sfb.getSubFeeType()+"&duration="+sfb.getDuration()+"''><button class='btn btn-info'>Edit</button></a>");
                  out.println("<a href='#'><button class='btn btn-danger' onclick='deleteSubFeeCheck("+sfb.getSubFeeTypeId()+")'>Delete</button></a>");
                  out.println("</center></td>");
                  out.println("</tr>");
               
           }
           else
           {
               out.println("<tr>");
               out.println("<td colspan='1'>");
               out.println("<b>No Record Found</b>");
               out.println("</td>");
               out.println("</tr>");}
        }finally {            
            out.close();
        }
    }


    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try {
            processRequest(request, response);
        } catch (SQLException ex) {
            Logger.getLogger(SearchSubFeeHead.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try {
            processRequest(request, response);
        } catch (SQLException ex) {
            Logger.getLogger(SearchSubFeeHead.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}
